News

Try out AS3FlexDB version 2.0.0.

Simple example

```

<mx:Button label="Get Users" click="st1.execute()"/>

<mx:DataGrid id="dg1" dataProvider="{users}">
    <mx:columns>
        <mx:DataGridColumn headerText="#ID" dataField="idUser" />
        <mx:DataGridColumn headerText="Username" dataField="username" />
        <mx:DataGridColumn headerText="Password" dataField="password" />
    </mx:columns>
</mx:DataGrid>

<!-- ++++++++++++++++++++++++++++ -->
<!-- AS3FlexDB code -->

<as3flexdb:MySQLAdapter id="defaultAdapter" host="localhost" database="dbtest"/>
<as3flexdb:SQLConnection id="conn1" sqlAdapter="{defaultAdapter}"/>

<as3flexdb:SQLStatement id="st1"
            sqlConnection="{conn1}"
            text="SELECT * FROM users WHERE 1"
            sqlResult="sqlResultHandler(event)"
            sqlError="sqlErrorHandler(event)"/>

<mx:Script>
    <![CDATA[

        import phi.framework.sql.*;
        import mx.collections.ArrayCollection;


        [Bindable]
        protected var users :ArrayCollection = new ArrayCollection();

        protected function sqlResultHandler(event:SQLEvent):void
        {
            var result :SQLResult = event.result;

            users.removeAll();

            // trace result
            for each( var item :Object in result.data )
                users.addItem( item );
        }


        protected function sqlErrorHandler(event:SQLErrorEvent):void
        {
            trace( event.error );   
        }

    ]]>
</mx:Script>

```

About AS3FlexDB

AS3FlexDB project is a open source library that allows Adobe Flex applications to connect to a MySQL server.This library use AMFPHP to access a MySQL server.

Download the source code. You can learn how to use FlexDB by following the steps in this tutorial.

For any questions email us at: as3flexdb@gmail.com

Take a look at FlexDB Tutorial 1 tutorial from iTutorials.ro

Version changes

• 1.0.0

  1. • Repackaged zip

• 1.1.2

  1. • Add getDefaultConnection(), setDefaultConnection();

• 1.2.0

  1. • Add query stack for oreder execute.

• 1.3.0

  1. • Add isStackEmpty();
  2. • Change setBusyCursor() whith "cool" preloader :D

• 1.4.0

  1. • Add support for use in MXML (ConnectionData, Query, Database)
  2. • Add set/get Records (bindable support)
  3. • Add QueryExecute class for use in MXML

Simple example

All you need to load a table (for ex. "users") into a datagrid after you have install amfphp and set "services-config.xml" correctly is :

```

<mx:DataGrid
    id="dg1"
    width="100%"
    height="100%"
    dataProvider="{q1.Records}">
    <mx:columns>
        <mx:DataGridColumn dataField="fname" headerText="First Name"/>
        <mx:DataGridColumn dataField="lname" headerText="Last Name"/>
        <mx:DataGridColumn dataField="password" headerText="Password"/>
    </mx:columns>
</mx:DataGrid>

<phi:ConnectionData id="c1" name="mxml_conn1" host="localhost" db="test" username="root" password="root" />
<phi:Database id="db1" connection="{c1}" />
<phi:Query id="q1" database="{db1}" q="SELECT * FROM users WHERE 1" />
<phi:QueryExecute id="q1ex" query="{q1}" />

```

Table structures is:

CREATE TABLE `users` ( `id` int(5) NOT NULL auto_increment, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `fname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;